TRAVERSE Global v11.1

Update Perpetual Inventory

Use the Update perpetual Inventory function to update on-hand item quantities by the difference between the frozen quantity and the physical counts you entered, and the COGS adjustments by the variance amounts.

The variance amounts are based on the inventory valuation method you use. If you use the LIFO or the FIFO method and no cost is available (for example, because the item has no on-hand quantity), the system updates the COGS adjustment amounts by the average cost of the item.

If you interface Inventory with General Ledger and you elect to post the variance amount to GL, entries are made to the inventory adjustment and physical count adjustment accounts:

  • Variance: Increase in Inventory
    AccountEntry
    Inventory AdjustmentDebit
    Physical Counts AdjustmentCredit
  • Variance: Decrease in Inventory
    AccountEntry
    Inventory AdjustmentCredit
    Physical Counts AdjustmentDebit

NOTE: You cannot post the variance amount to closed accounting periods. Use the System Manager Period Conversion function to open closed accounting periods, if necessary.

If Inventory is not interfaced with General Ledger, use the Update Perpetual Inventory Log to manually adjust the accounts affected by this function.

The IN adjustment and physical count adjustment accounts will come from the account code set up for each item in the location of the count.

NOTE: If your Inventory Adjustment Account is not set up with the same account as your Inventory Account: Normal accounting procedures suggest doing manual adjusting entries to reverse your physical count adjustment amounts out of your inventory adjustments account, and put the corresponding entry to your inventory account for the items that have had a quantity change. This will result in the true value of your inventory, reflected in your inventory account.

To update perpetual inventory:

  1. Complete entering physical inventory for the batches.
  2. Print the variance report for the batches.
  3. Select the Do the following then check the box check box.
  4. Select the batches to update perpetual inventory from the Selection List section.
    Note:The batches you select lock during processing to prevent other users from editing them. A message indicates whether the selected batches are locked because they are being used on the Physical Counts Tag Entry or Physical Counts Worksheet Entry screen. You can elect to remove the batches from the selected list.
  5. Select the Post Variance Amount to General Ledger check box to post the variance in General Ledger.
    Note: This option appears only if you interface Inventory with General Ledger in Business Rules.
  6. Enter comments for the post, if applicable, in the Comments field. These comments are stored in the Post Run field in the general ledger and can be seen on the GL Journal pick screen.
  7. Click a command button to
  8. Click To
    OK Begin posting.
    Activity Display the Activity Log form to show posting activity.
    Reset Set all fields to their default values.